What is your Data Source and Validation in Access issue?
Responses:
Subform show only one record when there is plenty of room
The text displayed in the combo box is from the wrong column
How to: Bind a control to data in a query or table
How to: Change Control Source for text box when field name in table has changed.
How to: Combine text and a field in a text box
How to: Require data in a field
How to: Validate data entered in a control
